Attribute | Description | Physical Name | Domain | Data Type | Foreign Key Table |
TransactionID (FK)(PK) | A universally unique identifier (UUID) for the Transaction. This may be assembled from alternate key members. | ID_TRN | IdentityUUID | char(32) | RetailTransaction(TR_RTL) |
TransactionTotalTypeCode (FK)(PK) | A unique assigned mnemonic identifier that identifies the TransactionTotalType | TY_TRN_TOT | Code | varchar(20) | TransactionTotalType(TR_TOT_TYP) |
Amount | The monetary value of the transaction total. | MO_TOT_RTL_TRN | Money | decimal(16,5) | |
UnitCount | A RetailTransaction level count of SKU's, line items, promotions or other kinds of discrete unit counts used to characterize RetailTransactions. Count, like Amount can be trea | QU_ITM_CNT | Quantity | DECIMAL(9,3) | |